load data
 infile 'D:\Userdata\db\personnel.csv'
 into table personnel
 replace
 fields terminated by "," optionally enclosed by '"'
 trailing nullcols
  (pemail char "TRIM (:pemail)", pphone char "TRIM (:pphone)", pfname char "TRIM (:pfname)", plname char "TRIM (:plname)", uname char "TRIM (:uname)")